/*
 Navicat Premium Data Transfer

 Source Server         : 台式
 Source Server Type    : MySQL
 Source Server Version : 50740
 Source Host           : 10.196.11.254:3306
 Source Schema         : shushan-base

 Target Server Type    : MySQL
 Target Server Version : 50740
 File Encoding         : 65001

 Date: 24/08/2023 17:48:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers` (
  `sched_name` varchar(120) NOT NULL,
  `trigger_name` varchar(200) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  `blob_data` blob,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_blob_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars` (
  `sched_name` varchar(120) NOT NULL,
  `calendar_name` varchar(200) NOT NULL,
  `calendar` blob NOT NULL,
  PRIMARY KEY (`sched_name`,`calendar_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_calendars
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `sched_name` varchar(120) NOT NULL,
  `trigger_name` varchar(200) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  `cron_expression` varchar(200) NOT NULL,
  `time_zone_id` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `sched_name` varchar(120) NOT NULL,
  `entry_id` varchar(95) NOT NULL,
  `trigger_name` varchar(200) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  `instance_name` varchar(200) NOT NULL,
  `fired_time` bigint(13) NOT NULL,
  `sched_time` bigint(13) NOT NULL,
  `priority` int(11) NOT NULL,
  `state` varchar(16) NOT NULL,
  `job_name` varchar(200) DEFAULT NULL,
  `job_group` varchar(200) DEFAULT NULL,
  `is_nonconcurrent` varchar(1) DEFAULT NULL,
  `requests_recovery` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`sched_name`,`entry_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_fired_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `sched_name` varchar(120) NOT NULL,
  `job_name` varchar(200) NOT NULL,
  `job_group` varchar(200) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `job_class_name` varchar(250) NOT NULL,
  `is_durable` varchar(1) NOT NULL,
  `is_nonconcurrent` varchar(1) NOT NULL,
  `is_update_data` varchar(1) NOT NULL,
  `requests_recovery` varchar(1) NOT NULL,
  `job_data` blob,
  PRIMARY KEY (`sched_name`,`job_name`,`job_group`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `sched_name` varchar(120) NOT NULL,
  `lock_name` varchar(40) NOT NULL,
  PRIMARY KEY (`sched_name`,`lock_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_locks` VALUES ('RuoyiScheduler', 'STATE_ACCESS');
INSERT INTO `qrtz_locks` VALUES ('RuoyiScheduler', 'TRIGGER_ACCESS');
INSERT INTO `qrtz_locks` VALUES ('ShushanScheduler', 'STATE_ACCESS');
INSERT INTO `qrtz_locks` VALUES ('ShushanScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `sched_name` varchar(120) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  PRIMARY KEY (`sched_name`,`trigger_group`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_paused_trigger_grps
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `sched_name` varchar(120) NOT NULL,
  `instance_name` varchar(200) NOT NULL,
  `last_checkin_time` bigint(13) NOT NULL,
  `checkin_interval` bigint(13) NOT NULL,
  PRIMARY KEY (`sched_name`,`instance_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_scheduler_state` VALUES ('RuoyiScheduler', 'HuangXiongdeMac-mini.local1692870319698', 1692870488993, 15000);
INSERT INTO `qrtz_scheduler_state` VALUES ('ShushanScheduler', 'HuangXiongdeMac-mini.local1692003482721', 1692003650181, 15000);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `sched_name` varchar(120) NOT NULL,
  `trigger_name` varchar(200) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  `repeat_count` bigint(7) NOT NULL,
  `repeat_interval` bigint(12) NOT NULL,
  `times_triggered` bigint(10) NOT NULL,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_simple_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `sched_name` varchar(120) NOT NULL,
  `trigger_name` varchar(200) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  `str_prop_1` varchar(512) DEFAULT NULL,
  `str_prop_2` varchar(512) DEFAULT NULL,
  `str_prop_3` varchar(512) DEFAULT NULL,
  `int_prop_1` int(11) DEFAULT NULL,
  `int_prop_2` int(11) DEFAULT NULL,
  `long_prop_1` bigint(20) DEFAULT NULL,
  `long_prop_2` bigint(20) DEFAULT NULL,
  `dec_prop_1` decimal(13,4) DEFAULT NULL,
  `dec_prop_2` decimal(13,4) DEFAULT NULL,
  `bool_prop_1` varchar(1) DEFAULT NULL,
  `bool_prop_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_simprop_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `sched_name` varchar(120) NOT NULL,
  `trigger_name` varchar(200) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  `job_name` varchar(200) NOT NULL,
  `job_group` varchar(200) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `next_fire_time` bigint(13) DEFAULT NULL,
  `prev_fire_time` bigint(13) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `trigger_state` varchar(16) NOT NULL,
  `trigger_type` varchar(8) NOT NULL,
  `start_time` bigint(13) NOT NULL,
  `end_time` bigint(13) DEFAULT NULL,
  `calendar_name` varchar(200) DEFAULT NULL,
  `misfire_instr` smallint(2) DEFAULT NULL,
  `job_data` blob,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  KEY `sched_name` (`sched_name`,`job_name`,`job_group`) USING BTREE,
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `job_name`, `job_group`) REFERENCES `qrtz_job_details` (`sched_name`, `job_name`, `job_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_column_setting
-- ----------------------------
DROP TABLE IF EXISTS `sys_column_setting`;
CREATE TABLE `sys_column_setting` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `path` varchar(128) COLLATE utf8mb4_bin NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '列名',
  `update_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `visible` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '是否展示',
  `sort` int(3) DEFAULT '0' COMMENT '排序',
  `width` varchar(5) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '列宽',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of sys_column_setting
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '父部门id',
  `ancestors` varchar(50) DEFAULT '' COMMENT '祖级列表',
  `name` varchar(30) DEFAULT '' COMMENT '部门名称',
  `weight` int(4) DEFAULT '0' COMMENT '显示顺序',
  `leader` varchar(20) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `status` char(1) DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES (1, 0, '', '开发部', 0, '石敢当', '999', NULL, '0', '0', 'admin', '2022-07-21 17:27:05', '', '2022-07-22 10:17:24');
INSERT INTO `sys_dept` VALUES (2, 1, '', '研发部', 2, '石敢当', '', NULL, '0', '0', 'admin', '2022-07-22 10:12:54', 'admin', '2022-12-26 17:28:02');
INSERT INTO `sys_dept` VALUES (3, 0, '', '采购部', 0, '', NULL, NULL, '0', '0', 'admin', '2022-12-26 17:28:11', 'admin', '2022-12-26 17:28:11');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `sort` int(4) DEFAULT '0' COMMENT '字典排序',
  `label` varchar(100) DEFAULT '' COMMENT '字典标签',
  `value` varchar(100) DEFAULT '' COMMENT '字典键值',
  `type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='字典数据表';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_data` VALUES (124, 0, '男', '0', 'sex', 'admin', '2022-12-14 14:39:21', 'admin', '2022-12-14 14:39:21', NULL);
INSERT INTO `sys_dict_data` VALUES (126, 0, '女', '1', 'sex', 'admin', '2022-12-14 15:19:01', 'admin', '2022-12-14 15:19:01', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `name` varchar(100) DEFAULT '' COMMENT '字典名称',
  `type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `dict_type` (`type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='字典类型表';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` VALUES (32, '性别', 'sex', 'admin', '2022-12-14 14:39:13', 'admin', '2022-12-14 14:39:13');
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务ID',
  `job_name` varchar(64) NOT NULL DEFAULT '' COMMENT '任务名称',
  `job_group` varchar(64) NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
  `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',
  `cron_expression` varchar(255) DEFAULT '' COMMENT 'cron执行表达式',
  `misfire_policy` varchar(20) DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
  `concurrent` char(1) DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1暂停）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注信息',
  PRIMARY KEY (`job_id`,`job_name`,`job_group`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务调度表';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_job_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_job_log`;
CREATE TABLE `sys_job_log` (
  `job_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志ID',
  `job_name` varchar(64) NOT NULL COMMENT '任务名称',
  `job_group` varchar(64) NOT NULL COMMENT '任务组名',
  `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',
  `job_message` varchar(500) DEFAULT NULL COMMENT '日志信息',
  `status` char(1) DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
  `exception_info` varchar(2000) DEFAULT '' COMMENT '异常信息',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_log_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务调度日志表';

-- ----------------------------
-- Records of sys_job_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_login_log`;
CREATE TABLE `sys_login_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `user_name` varchar(50) DEFAULT '' COMMENT '用户账号',
  `ipaddr` varchar(50) DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) DEFAULT '' COMMENT '登录地点',
  `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',
  `os` varchar(50) DEFAULT '' COMMENT '操作系统',
  `status` char(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) DEFAULT '' COMMENT '提示消息',
  `login_time` datetime DEFAULT NULL COMMENT '访问时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=418 DEFAULT CHARSET=utf8mb4 COMMENT='系统访问记录';

-- ----------------------------
-- Records of sys_login_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_login_log` VALUES (417, 1, 'admin', '0:0:0:0:0:0:0:1', '内网IP(内网IP)', 'Chrome', 'OSX', '0', '登陆成功', '2023-08-24 17:45:44');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
                          `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
                          `name` varchar(50) NOT NULL COMMENT '菜单名称',
                          `parent_id` bigint(20) DEFAULT '0' COMMENT '父菜单ID',
                          `weight` int(4) DEFAULT '0' COMMENT '显示顺序',
                          `path` varchar(200) DEFAULT '' COMMENT '路由地址',
                          `menu_key` varchar(255) DEFAULT NULL COMMENT '组件路径',
                          `iframe` char(1) DEFAULT '1' COMMENT '是否为外链（0是 1否）',
                          `type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
                          `hide` char(1) DEFAULT '1' COMMENT '菜单状态（0隐藏 1显示 ）',
                          `status` char(1) DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
                          `permission` varchar(100) DEFAULT NULL COMMENT '权限标识',
                          `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
                          `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
                          `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                          `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
                          `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                          `remark` varchar(500) DEFAULT '' COMMENT '备注',
                          `keep_alive` char(1) DEFAULT '0' COMMENT '页面缓存',
                          `href` varchar(255) DEFAULT NULL COMMENT '外链url',
                          `watermark` char(1) DEFAULT '1' COMMENT '是否有水印（0有 1无）',
                          PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COMMENT='菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (2, '工作台', 0, 2, '/dashboard', 'dashboard', '1', 'P', '1', '0', '', 'icon-park-outline:workbench', '', '2022-07-20 10:54:13', '', '2022-07-20 10:54:13', '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (3, '系统管理', 0, 3, '/sys', 'sys', '1', 'M', '1', '0', '', 'carbon:cloud-service-management', '', '2022-07-20 10:56:22', '', '2022-07-20 10:56:22', '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (4, '角色管理', 3, 2, '/sys/role', 'system_role', '1', 'P', '1', '0', '', '', '', '2022-07-20 10:58:40', 'admin', '2022-12-02 17:52:50', '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (8, '菜单管理', 3, 2, '/sys/menu', 'system_menu', '1', 'P', '1', '0', '', '', NULL, NULL, 'admin', '2022-12-02 17:53:08', '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (10, '部门管理', 3, 2, '/sys/dept', 'system_dept', '1', 'P', '1', '0', '', '', 'admin', '2022-07-21 17:24:42', 'admin', '2022-12-02 17:53:04', '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (11, '用户管理', 3, 1, '/sys/user', 'system_user', '1', 'P', '1', '0', '', '', 'admin', '2022-07-22 15:37:52', 'admin', '2023-11-23 08:52:00', '', '0', '', '0');
INSERT INTO `sys_menu` VALUES (16, '系统日志', 3, 2, '/sys/log', 'system_log', '1', 'M', '1', '0', '', '', 'admin', '2022-11-18 16:52:26', 'admin', '2023-06-13 11:18:11', '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (17, '操作日志', 16, 0, '/sys/log/operate', 'system_log_operate-log', '1', 'P', '1', '0', '', '', 'admin', '2022-11-18 16:53:08', 'admin', '2023-11-23 08:57:51', '', '0', '', '0');
INSERT INTO `sys_menu` VALUES (18, '登录日志', 16, 0, '/sys/log/login', 'system_log_login-log', '1', 'P', '1', '0', '', '', 'admin', '2022-11-18 16:54:07', 'admin', '2023-11-23 08:57:54', '', '0', '', '0');
INSERT INTO `sys_menu` VALUES (19, '数据字典', 3, 2, '/sys/dict', 'system_dict', '1', 'P', '1', '0', '', '', 'admin', '2022-12-02 17:20:32', 'admin', '2022-12-02 17:52:57', '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (20, '定时任务', 3, 2, '/sys/task', 'system_schedule-task', '1', 'P', '1', '0', '', '', 'admin', '2022-12-02 17:27:20', 'admin', '2022-12-02 17:52:54', '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (23, '监控面板', 24, 0, '/monitor/monitor', 'monitor_monitor', '1', 'P', '1', '0', '', '', 'admin', '2022-12-07 08:46:37', 'admin', '2022-12-14 16:33:15', '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (24, '系统监控', 0, 5, '/monitor', 'monitor', '1', 'M', '1', '0', '', 'carbon:cloud-monitoring', 'admin', '2022-12-09 17:51:39', 'admin', '2022-12-14 16:31:02', '', '1', NULL, '1');
INSERT INTO `sys_menu` VALUES (25, '在线用户', 24, 0, '/monitor/online', 'monitor_online', '1', 'P', '1', '0', '', '', 'admin', '2022-12-09 17:52:26', 'admin', '2022-12-09 17:52:46', '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (26, '查询列表权限', 11, 0, '/', '/', '1', 'B', '1', '0', 'system:user:list', '', 'test', '2023-03-13 09:13:25', 'test', '2023-03-13 09:13:48', '', '1', NULL, '1');
INSERT INTO `sys_menu` VALUES (27, '查询明细权限', 11, 0, '/', '/', '1', 'B', '1', '0', 'system:user:query', '', 'test', '2023-03-13 09:14:08', 'test', '2023-03-13 09:14:31', '', '1', NULL, '1');
INSERT INTO `sys_menu` VALUES (28, '新增权限', 11, 0, '/', '/', '1', 'B', '1', '0', 'system:user:add', '', 'test', '2023-03-13 09:14:27', 'test', '2023-03-13 09:16:40', '', '1', NULL, '1');
INSERT INTO `sys_menu` VALUES (29, '修改权限', 11, 0, '/', '/', '1', 'B', '1', '0', 'system:user:edit', '', 'test', '2023-03-13 09:14:58', 'test', '2023-03-13 09:14:58', '', '1', NULL, '1');
INSERT INTO `sys_menu` VALUES (30, '删除权限', 11, 0, '/', '/', '1', 'B', '1', '0', 'system:user:remove', '', 'test', '2023-03-13 09:15:23', 'test', '2023-03-13 09:15:23', '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (31, '角色列表', 4, 0, '/', '/', '1', 'B', '1', '0', 'system:role:list', '#', 'admin', '2023-03-13 01:24:06', '', NULL, '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (32, '角色查询', 4, 1, '/', '/', '1', 'B', '1', '0', 'system:role:query', '#', 'admin', '2023-03-13 01:24:06', '', NULL, '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (33, '角色新增', 4, 2, '/', '/', '1', 'B', '1', '0', 'system:role:add', '', 'admin', '2023-03-13 01:24:06', '', NULL, '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (34, '角色修改', 4, 3, '/', '/', '1', 'B', '1', '0', 'system:role:edit', '', 'admin', '2023-03-13 01:24:06', '', NULL, '', '0', NULL, '1');
INSERT INTO `sys_menu` VALUES (35, '角色删除', 4, 4, '/', '/', '1', 'B', '1', '0', 'system:role:remove', '', 'admin', '2023-03-13 01:24:07', '', NULL, '', '0', NULL, '1');
COMMIT;

-- ----------------------------
-- Table structure for sys_operate_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_operate_log`;
CREATE TABLE `sys_operate_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `module` varchar(50) DEFAULT '' COMMENT '模块标题',
  `name` varchar(50) DEFAULT '' COMMENT '操作名称',
  `business_type` int(2) DEFAULT '0' COMMENT '业务类型 @link BusinessType',
  `method` varchar(100) DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',
  `operator_type` varchar(20) DEFAULT 'sysUser' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_user_id` varchar(50) DEFAULT '' COMMENT '操作人员id',
  `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',
  `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(50) DEFAULT '' COMMENT '主机地址',
  `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点',
  `oper_param` varchar(2000) DEFAULT '' COMMENT '请求参数',
  `json_result` varchar(2000) DEFAULT '' COMMENT '返回参数',
  `status` int(1) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息',
  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
  `consume_time` bigint(20) DEFAULT NULL  COMMENT '操作耗时',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=utf8mb4 COMMENT='操作日志记录';

-- ----------------------------
-- Records of sys_operate_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_quick_link
-- ----------------------------
DROP TABLE IF EXISTS `sys_quick_link`;
CREATE TABLE `sys_quick_link` (
  `id` bigint(20) NOT NULL,
  `name` varchar(20) COLLATE utf8mb4_croatian_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_croatian_ci NOT NULL,
  `color` varchar(20) COLLATE utf8mb4_croatian_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_croatian_ci DEFAULT NULL,
  `is_iframe` char(1) COLLATE utf8mb4_croatian_ci NOT NULL DEFAULT 'n' COMMENT '是否外链：Y 是 N 否',
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  `create_by` varchar(64) COLLATE utf8mb4_croatian_ci NOT NULL,
  `sort` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_croatian_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_quick_link
-- ----------------------------
BEGIN;
INSERT INTO `sys_quick_link` VALUES (1589873822794436609, '百度一下', 'https://www.baidu.com/', '#55efc4', 'uil:basketball', 'y', '2022-11-08 00:00:00', '2022-11-08 00:00:00', 'cheng', 0);
INSERT INTO `sys_quick_link` VALUES (1669596262882557954, '用户管理', '/sys/user', '#409EFF', 'mdi:emoticon', 'n', '2023-06-16 14:42:23', '2023-06-16 14:42:23', 'admin', 0);
INSERT INTO `sys_quick_link` VALUES (1669596444642721794, 'echats', '/example/echart', '#409EFF', 'ph:align-bottom', 'n', '2023-06-16 14:43:07', '2023-06-16 14:43:07', 'admin', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) COLLATE utf8mb4_croatian_ci NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) COLLATE utf8mb4_croatian_ci NOT NULL COMMENT '角色权限字符串',
  `data_scope` char(1) COLLATE utf8mb4_croatian_ci DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `status` char(1) COLLATE utf8mb4_croatian_ci NOT NULL COMMENT '角色状态（0正常 1停用）',
  `del_flag` char(1) COLLATE utf8mb4_croatian_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) COLLATE utf8mb4_croatian_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_croatian_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '备注',
  `home_page` varchar(100) COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '角色默认首页',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_croatian_ci COMMENT='角色信息表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '管理员', 'admin', '2', '0', '0', '', '2022-07-11 00:00:00', 'admin', '2022-07-21 00:00:00', NULL, 'dashboard');
INSERT INTO `sys_role` VALUES (6, '测试管理员', 'test', '2', '0', '0', 'admin', '2022-11-24 00:00:00', 'admin', '2023-05-10 14:52:24', NULL, 'dashboard');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`,`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_croatian_ci COMMENT='角色和部门关联表';

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_dept` VALUES (1, 1);
INSERT INTO `sys_role_dept` VALUES (1, 2);
INSERT INTO `sys_role_dept` VALUES (6, 3);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色和菜单关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (1, 1);
INSERT INTO `sys_role_menu` VALUES (1, 2);
INSERT INTO `sys_role_menu` VALUES (1, 3);
INSERT INTO `sys_role_menu` VALUES (1, 4);
INSERT INTO `sys_role_menu` VALUES (1, 8);
INSERT INTO `sys_role_menu` VALUES (1, 10);
INSERT INTO `sys_role_menu` VALUES (1, 11);
INSERT INTO `sys_role_menu` VALUES (1, 13);
INSERT INTO `sys_role_menu` VALUES (1, 14);
INSERT INTO `sys_role_menu` VALUES (1, 15);
INSERT INTO `sys_role_menu` VALUES (2, 1);
INSERT INTO `sys_role_menu` VALUES (2, 2);
INSERT INTO `sys_role_menu` VALUES (2, 3);
INSERT INTO `sys_role_menu` VALUES (2, 4);
INSERT INTO `sys_role_menu` VALUES (2, 8);
INSERT INTO `sys_role_menu` VALUES (2, 10);
INSERT INTO `sys_role_menu` VALUES (2, 11);
INSERT INTO `sys_role_menu` VALUES (6, 1);
INSERT INTO `sys_role_menu` VALUES (6, 2);
INSERT INTO `sys_role_menu` VALUES (6, 3);
INSERT INTO `sys_role_menu` VALUES (6, 4);
INSERT INTO `sys_role_menu` VALUES (6, 8);
INSERT INTO `sys_role_menu` VALUES (6, 10);
INSERT INTO `sys_role_menu` VALUES (6, 11);
INSERT INTO `sys_role_menu` VALUES (6, 16);
INSERT INTO `sys_role_menu` VALUES (6, 17);
INSERT INTO `sys_role_menu` VALUES (6, 20);
INSERT INTO `sys_role_menu` VALUES (6, 26);
INSERT INTO `sys_role_menu` VALUES (6, 27);
INSERT INTO `sys_role_menu` VALUES (6, 28);
INSERT INTO `sys_role_menu` VALUES (6, 29);
INSERT INTO `sys_role_menu` VALUES (6, 30);
INSERT INTO `sys_role_menu` VALUES (6, 31);
INSERT INTO `sys_role_menu` VALUES (6, 32);
INSERT INTO `sys_role_menu` VALUES (6, 33);
INSERT INTO `sys_role_menu` VALUES (6, 34);
INSERT INTO `sys_role_menu` VALUES (6, 35);
INSERT INTO `sys_role_menu` VALUES (7, 2);
INSERT INTO `sys_role_menu` VALUES (7, 3);
INSERT INTO `sys_role_menu` VALUES (7, 4);
INSERT INTO `sys_role_menu` VALUES (7, 8);
INSERT INTO `sys_role_menu` VALUES (7, 10);
INSERT INTO `sys_role_menu` VALUES (7, 11);
INSERT INTO `sys_role_menu` VALUES (7, 13);
INSERT INTO `sys_role_menu` VALUES (7, 14);
INSERT INTO `sys_role_menu` VALUES (7, 15);
INSERT INTO `sys_role_menu` VALUES (7, 16);
INSERT INTO `sys_role_menu` VALUES (7, 17);
INSERT INTO `sys_role_menu` VALUES (7, 18);
INSERT INTO `sys_role_menu` VALUES (7, 19);
INSERT INTO `sys_role_menu` VALUES (7, 20);
INSERT INTO `sys_role_menu` VALUES (7, 23);
INSERT INTO `sys_role_menu` VALUES (7, 24);
INSERT INTO `sys_role_menu` VALUES (8, 2);
INSERT INTO `sys_role_menu` VALUES (8, 3);
INSERT INTO `sys_role_menu` VALUES (8, 4);
INSERT INTO `sys_role_menu` VALUES (8, 8);
INSERT INTO `sys_role_menu` VALUES (8, 10);
INSERT INTO `sys_role_menu` VALUES (8, 11);
INSERT INTO `sys_role_menu` VALUES (8, 16);
INSERT INTO `sys_role_menu` VALUES (8, 17);
INSERT INTO `sys_role_menu` VALUES (8, 18);
INSERT INTO `sys_role_menu` VALUES (8, 19);
INSERT INTO `sys_role_menu` VALUES (8, 20);
INSERT INTO `sys_role_menu` VALUES (8, 23);
INSERT INTO `sys_role_menu` VALUES (8, 24);
INSERT INTO `sys_role_menu` VALUES (8, 25);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `user_name` varchar(30) COLLATE utf8mb4_croatian_ci NOT NULL COMMENT '用户账号',
  `nick_name` varchar(30) COLLATE utf8mb4_croatian_ci NOT NULL COMMENT '用户昵称',
  `email` varchar(50) COLLATE utf8mb4_croatian_ci DEFAULT '' COMMENT '用户邮箱',
  `phone` varchar(11) COLLATE utf8mb4_croatian_ci DEFAULT '' COMMENT '手机号码',
  `sex` char(1) COLLATE utf8mb4_croatian_ci DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(100) COLLATE utf8mb4_croatian_ci DEFAULT '' COMMENT '头像地址',
  `password` varchar(100) COLLATE utf8mb4_croatian_ci NOT NULL DEFAULT '' COMMENT '密码',
  `status` char(1) COLLATE utf8mb4_croatian_ci DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` char(1) COLLATE utf8mb4_croatian_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `login_ip` varchar(50) COLLATE utf8mb4_croatian_ci DEFAULT '' COMMENT '最后登陆IP',
  `login_date` datetime DEFAULT NULL COMMENT '最后登陆时间',
  `create_by` varchar(64) COLLATE utf8mb4_croatian_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_croatian_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '备注',
  `df_pw` char(1) COLLATE utf8mb4_croatian_ci NOT NULL DEFAULT '0' COMMENT '是否默认密码',
  `ban` char(1) COLLATE utf8mb4_croatian_ci NOT NULL DEFAULT '1' COMMENT '是否被封禁',
  `login_err_of_day` int(10) NOT NULL DEFAULT '0' COMMENT '当天的登录错误次数，登录错误超过一定次数，用户会被封禁',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_croatian_ci COMMENT='用户信息表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 2, 'admin', 'admin', '', '', '0', '', '82d19ec45c9efe84bb1cdfbe460fb414', '0', '0', '0:0:0:0:0:0:0:1', '2023-08-24 17:45:44', '', '2022-07-11 00:00:00', NULL, NULL, NULL, '1', '1', 0);
INSERT INTO `sys_user` VALUES (3, 2, '123', '石敢当1', '', '', '0', '', '82d19ec45c9efe84bb1cdfbe460fb414', '0', '2', '127.0.0.1', '2022-07-22 00:00:00', 'admin', '2022-07-22 00:00:00', 'admin', '2022-11-18 17:00:20', NULL, '0', '1', 0);
INSERT INTO `sys_user` VALUES (4, 3, 'test', '测试用户', '', '', '0', '', '82d19ec45c9efe84bb1cdfbe460fb414', '0', '0', '0:0:0:0:0:0:0:1', '2023-03-13 09:34:34', 'admin', '2022-11-24 00:00:00', NULL, NULL, NULL, '0', '1', 0);
INSERT INTO `sys_user` VALUES (5, 3, 'test02', 'test20221226', '', '', '0', '', '82d19ec45c9efe84bb1cdfbe460fb414', '0', '2', '127.0.0.1', '2023-02-01 09:58:43', 'test', '2022-12-26 00:00:00', 'admin', '2023-03-13 08:49:44', NULL, '0', '1', 0);
INSERT INTO `sys_user` VALUES (6, 1, 't20230109', 'test', 'huangxiong@163.com', '', '女', '', '', '0', '2', '', NULL, 'admin', '2023-01-09 15:57:18', 'admin', '2023-01-09 15:58:10', NULL, '0', '1', 0);
INSERT INTO `sys_user` VALUES (8, 1, 't20230109', 'test', 'huangxiong@163.com', '', '0', '', '', '0', '2', '', NULL, 'admin', '2023-01-09 16:05:05', 'admin', '2023-01-09 16:05:31', NULL, '0', '1', 0);
INSERT INTO `sys_user` VALUES (9, 1, 'TEST01', '测试', '', '', '0', '', '', '0', '2', '', NULL, 'admin', '2023-02-01 09:51:15', 'admin', '2023-02-01 09:51:34', NULL, '0', '1', 0);
INSERT INTO `sys_user` VALUES (10, 1, 'TEST01', '测试', '', '', '0', '', '', '0', '2', '', NULL, 'admin', '2023-02-01 09:51:45', 'admin', '2023-02-01 09:52:06', NULL, '0', '1', 0);
INSERT INTO `sys_user` VALUES (11, 1, 'TEST01', '测试', '', '', '0', '', '', '0', '2', '', NULL, 'admin', '2023-02-01 09:51:54', 'admin', '2023-02-01 09:52:02', NULL, '0', '1', 0);
INSERT INTO `sys_user` VALUES (12, 1, 'test01', '测试', '', '', '0', '', '', '0', '2', '', NULL, 'admin', '2023-02-01 09:58:06', 'admin', '2023-02-01 09:58:27', NULL, '0', '1', 0);
INSERT INTO `sys_user` VALUES (16, NULL, '6', '777', '', '', '0', '', '777', '0', '0', '', NULL, NULL, NULL, NULL, NULL, NULL, '0', '1', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_croatian_ci COMMENT='用户和角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (1, 1);
INSERT INTO `sys_user_role` VALUES (3, 2);
INSERT INTO `sys_user_role` VALUES (4, 6);
INSERT INTO `sys_user_role` VALUES (5, 6);
INSERT INTO `sys_user_role` VALUES (13, 9);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
